package com.sto.stoapp.db.constant;

/**
 * 订单原因打回接口
 * 
 * @author mgf
 * 
 */
public interface StoOrderReasonConstant extends StoBaseConstant {

	/**
	 * 序号
	 */
	public static final String ORDER_SERIAL_NUMBER = "serial_number";

	/**
	 * 订单打回原因内容
	 */
	public static final String RECORD_CONTENT = "record_content";

	public static final String BACKUP1 = "backup1";

	/**
	 * 订单原因打回表
	 */
	public static final String ORDER_REASON_TABLE = "order_return_reason_table";

	/**
	 * 创建订单原因打回信息表
	 */
	public static final String CREATE_ORDER_REASON_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ ORDER_REASON_TABLE
			+ "("
			+ "id TEXT PRIMARY KEY "
			+ ","
			+ ORDER_SERIAL_NUMBER
			+ " text"
			+ ","
			+ RECORD_CONTENT
			+ " text"
			+ ","
			+ STATUS
			+ " text"
			+ ","
			+ VERSION
			+ " text "
			+ ","
			+ BACKUP1
			+ " text "
			+ ","

			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";

	/**
	 * 删除订单原因打回数据库表
	 */
	public static final String DROP_ORDER_REASON_TABLE = "drop table if exists "
			+ ORDER_REASON_TABLE;
}
